l108/opdracht auteurdetails/leerlinginfo.php

<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Document</title> <link rel="stylesheet" type="text/css" href="infostyle.css"> </head> <body> <?php include "../db.php"; include "../functions.php"; $llnr = $_GET["llnr"]; $result = mysqli_query($db, "SELECT * FROM leerlingen WHERE llnr = $llnr"); $values = mysqli_fetch_row($result); echo "<h1>$values[1] $values[2] $values[3]</h1>"; echo "<p>$values[4] $values[5] $values[7]</p>"; echo "<p>$values[6]</p>"; echo "<p>Geleende boeken:</p>"; $result = mysqli_query($db, "SELECT titel, datum_uit, auteurs.voornaam, auteurs.tussenvoegsel, auteurs.achternaam, boeken.boeknr, auteurs.auteurnr FROM auteurs, boeken, uitleningen, leerlingen WHERE auteurs.auteurnr = boeken.auteurnr AND boeken.boeknr = uitleningen.boeknr AND uitleningen.llnr = leerlingen.llnr AND leerlingen.llnr = $llnr"); $returnedvalue = "<table>"; for($i = 0; $i < mysqli_num_rows($result); $i++){ $values = mysqli_fetch_array($result); $returnedvalue .= "<tr>"; for($j = 0; $j < count($values)/2; $j++){ if($j == 0){ $returnedvalue .= "<td><a href='boekinfo.php?boeknr=$values[5]'>$values[$j]</a></td>"; } else if($j == 2){ $returnedvalue .= "<td><a href='auteurinfo.php?auteurnr=$values[6]'>$values[$j]</a></td>"; } else if ($j < 5){ $returnedvalue .= "<td>$values[$j]</td>"; } } $returnedvalue .= "</tr>"; } $returnedvalue .= "</table>"; $returnedvalue = str_replace("<table>", "<table style='border: 1px solid'>", $returnedvalue); $returnedvalue = str_replace("<td>", "<td style='border: 1px solid'>", $returnedvalue); echo $returnedvalue; //for($i = 0; $i < ) ?> <br><span><a href="leerlingen.php">Alle leerlingen</a></span> </body> </html>

Resultaat

Made by Thijs Aarnoudse